Limitations and considerations

The following limitations apply to the Amazon S3 target endpoint:

The following DDLs are supported only: Truncate table, Drop table, Create table, Add Column, Rename Column, Drop Column, and Convert Data Type.
Full LOB Mode is not supported
UPDATE and DELETE statements are not supported in Apply Changes replication mode
Batch optimized apply mode is not supported
Target lookup is not supported
The <target folder> parameter cannot include special characters
Limitations when using Parquet file format:
- When the DDL Handling Policy for source tables is set to Ignore ALTER, the RENAME COLUMN DDL (on a Primary Key column) is not supported.
- LOB columns larger than 1 MB are not supported.

Database names, schema names, or table names containing slash (/) or backslash (\) characters are not supported.
The following Control Tables are not supported as they require UPDATE/DELETE operations, which are not supported:
- Replication Status (requires UPDATE).
  Name on target: attrep_status
- Suspended Tables (requires DELETE).
  Name on target: attrep_suspended_tables
  For more information on Control Tables, see Control tables.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!